﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="shoozla-control-panel.aspx.cs" Inherits="ShoozlaWCFService.shoozla_control_panel" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Shoozla Control Panel</title>
    <style type="text/css">
        .style1
        {
            width: 54px;
            height: 49px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <img src="Images/title.png" style="height: 93px; width: 263px" />
        <br />
        <img alt="run" class="style1" src="Images/shoolza_icon.png" />
        <asp:Label 
            ID="totalRunLB" runat="server" Text="0" Font-Size="50pt" 
            ForeColor="Black"></asp:Label>
        
    </div>
</body>
</html>
<asp:sqldatasource runat="server" ID="GBSQL" 
    ConnectionString="<%$ ConnectionStrings:gianlucabertelliConnectionString %>" 
    SelectCommand="SELECT        C_COUNTRY, COUNT(C_COUNTRY) AS Expr1
FROM            TB_BUDDYNGER_STAT
GROUP BY C_COUNTRY
ORDER BY Expr1 DESC" 
        DataSourceMode="DataReader" EnableViewState="False" 
        ProviderName="<%$ ConnectionStrings:gianlucabertelliConnectionString.ProviderName %>"></asp:sqldatasource>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        CellPadding="4" DataSourceID="GBSQL" ForeColor="#333333" GridLines="None" 
        ShowHeader="False">
        <AlternatingRowStyle BackColor="White" />
        <Columns>
            <asp:BoundField DataField="C_COUNTRY" SortExpression="C_COUNTRY" />
            <asp:BoundField DataField="Expr1" ReadOnly="True" SortExpression="Expr1" />
        </Columns>
        <EditRowStyle BackColor="#2461BF" />
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#EFF3FB" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#F5F7FB" />
        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
        <SortedDescendingCellStyle BackColor="#E9EBEF" />
        <SortedDescendingHeaderStyle BackColor="#4870BE" />
    </asp:GridView>
    </form>

